package com.zhangtai.modules.dto;

import com.zhangtai.utils.Excel.ExcelAnnotation;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.math.BigDecimal;
import java.util.Date;

@Data
public class ExportSecurityRecordDto {

    /**
     * 序号
     */
    @ExcelAnnotation(rowName = "序号")
    private Double no;
    @ExcelAnnotation(rowName="姓名")
    private String name;
    @ExcelAnnotation(rowName="职位")
    private String jobname;
    @ExcelAnnotation(rowName="公司")
    private String orgname;
    @ExcelAnnotation(rowName="职级")
    private String joblevel;
    @ExcelAnnotation(rowName="社保缴纳单位")
    private String unitName;
    @ExcelAnnotation(rowName="社保缴纳地")
    private String cityName;
    @ExcelAnnotation(rowName="参保时间")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    private Date operateTime;
    @ExcelAnnotation(rowName="养老保险基数")
    private BigDecimal endowmentInsuranceBase;
    @ExcelAnnotation(rowName = "养老保险个人缴纳金额")
    private BigDecimal endowmentInsurancePerson;
    @ExcelAnnotation(rowName = "养老保险个人缴纳比例（%）")
    private BigDecimal endowmentInsurancePersonRate;
    @ExcelAnnotation(rowName = "养老保险公司缴纳金额")
    private BigDecimal endowmentInsuranceOrg;
    @ExcelAnnotation(rowName = "养老保险公司缴纳比例（%）")
    private BigDecimal endowmentInsuranceOrgRate;
    @ExcelAnnotation(rowName = "失业保险基数")
    private BigDecimal unemploymentInsuranceBase;
    @ExcelAnnotation(rowName = "失业保险个人缴纳金额")
    private BigDecimal unemploymentInsurancePerson;
    @ExcelAnnotation(rowName = "失业保险个人缴纳比例（%）")
    private BigDecimal unemploymentInsurancePersonRate;
    @ExcelAnnotation(rowName = "失业保险公司缴纳金额")
    private BigDecimal unemploymentInsuranceOrg;
    @ExcelAnnotation(rowName = "失业保险公司缴纳比例（%）")
    private BigDecimal unemploymentInsuranceOrgRate;
    @ExcelAnnotation(rowName = "医疗保险基数")
    private BigDecimal medicalInsuranceBase;
    @ExcelAnnotation(rowName = "医疗保险个人缴纳金额")
    private BigDecimal medicalInsurancePerson;
    @ExcelAnnotation(rowName = "医疗保险个人缴纳比例（%）")
    private BigDecimal medicalInsurancePersonRate;
    @ExcelAnnotation(rowName = "医疗保险公司缴纳金额")
    private BigDecimal medicalInsuranceOrg;
    @ExcelAnnotation(rowName = "医疗保险公司缴纳比例（%）")
    private BigDecimal medicalInsuranceOrgRate;
    @ExcelAnnotation(rowName = "工伤保险基数")
    private BigDecimal injuryInsuranceBase;
    @ExcelAnnotation(rowName = "工伤保险个人缴纳金额")
    private BigDecimal injuryInsurancePerson;
    @ExcelAnnotation(rowName = "工伤保险个人缴纳比例（%）")
    private BigDecimal injuryInsurancePersonRate;
    @ExcelAnnotation(rowName = "工伤保险公司缴纳金额")
    private BigDecimal injuryInsuranceOrg;
    @ExcelAnnotation(rowName = "工伤保险公司缴纳比例（%）")
    private BigDecimal injuryInsuranceOrgRate;
    @ExcelAnnotation(rowName = "大额医疗基数")
    private BigDecimal largerMedicalBase;
    @ExcelAnnotation(rowName = "大额医疗个人缴纳金额")
    private BigDecimal largerMedicalPerson;
    @ExcelAnnotation(rowName = "大额医疗个人缴纳比例（%）")
    private BigDecimal largerMedicalPersonRate;
    @ExcelAnnotation(rowName = "大额医疗公司缴纳金额")
    private BigDecimal largerMedicalOrg;
    @ExcelAnnotation(rowName = "重大医疗公司缴纳比例（%）")
    private BigDecimal largerMedicalOrgRate;
    @ExcelAnnotation(rowName="生育险基数")
    private BigDecimal maternityInsuranceBase;
    @ExcelAnnotation(rowName="生育险个人缴纳金额")
    private BigDecimal maternityInsurancePerson;
    @ExcelAnnotation(rowName="生育险个人缴纳比例（%）")
    private BigDecimal maternityInsurancePersonRate;
    @ExcelAnnotation(rowName="生育险公司缴纳金额")
    private BigDecimal maternityInsuranceOrg;
    @ExcelAnnotation(rowName="生育险公司缴纳比例（%）")
    private BigDecimal maternityInsuranceOrgRate;
    @ExcelAnnotation(rowName="残疾保障金基数")
    private BigDecimal disabledEmploymentBase;
    @ExcelAnnotation(rowName="残疾保障金个人缴纳金额")
    private BigDecimal disabledEmploymentPerson;
    @ExcelAnnotation(rowName="残疾保障金个人缴纳比例（%）")
    private BigDecimal disabledEmploymentPersonRate;
    @ExcelAnnotation(rowName="残疾保障金公司缴纳金额")
    private BigDecimal disabledEmploymentOrg;
    @ExcelAnnotation(rowName="残疾保障金公司缴纳比例（%）")
    private BigDecimal disabledEmploymentOrgRate;
    @ExcelAnnotation(rowName="公司缴纳合计")
    private BigDecimal orgCostTotal;
    @ExcelAnnotation(rowName="个人缴纳合计")
    private BigDecimal personCostTotal;
    @ExcelAnnotation(rowName="本月工资扣款合计")
    private BigDecimal salaryCost;
}
